Information and Data Quality in Spreadsheets
نویسنده
چکیده
The quality of the data in spreadsheets is less discussed than the structural integrity of the formulas. Yet it is an area of great interest to the owners and users of the spreadsheet. This paper provides an overview of Information Quality (IQ) and Data Quality (DQ) with specific reference to how data is sourced, structured, and presented in spreadsheets.
منابع مشابه
Exact and Near-miss Clone Detection in Spreadsheets
Spreadsheets are used extensively in business, in many domains. The applicability of software engineering methods to spreadsheets has been a topic of research for several years [2], but the main focus has been on analyzing the formulas, and not on analyzing the data in the spreadsheets. One of the factors that plays a role in spreadsheet data quality is the occurrence of clones in the spreadshe...
متن کاملBreviz: Visualizing Spreadsheets using Dataflow Diagrams
Spreadsheets are used extensively in industry, often for business critical purposes. In previous work we have analyzed the information needs of spreadsheet professionals and addressed their need for support with the transition of a spreadsheet to a colleague with the generation of data flow diagrams. In this paper we describe the application of these data flow diagrams for the purpose of unders...
متن کاملBreviz: Spreadsheet Visualization and Quality Analysis
Thanks to their flexibility and intuitive programming model, spreadsheets are widely used in industry, often for business-critical applications. Similar to software developers, professional spreadsheet users demand support for understanding spreadsheets, and analyzing their quality. This paper describes Breviz, a tool that visualizes spreadsheets as leveled dataflow diagrams, showing users all ...
متن کاملSpreadsheets for Geothermal Water and Gas Geochemistry
Two Excel spreadsheets released with this paper support many of the common graphical analyses of water and gas chemistry used to interpret hot spring, fumarole and well samples in geothermal exploration and development. Cross-plots and ternary diagrams are generated from measured concentrations of chemical species using formulas based on equilibrium reactions and empirical relationships. Typica...
متن کاملError Estimation in Large Spreadsheets using Bayesian Statistics
Spreadsheets are ubiquitous in business with the financial sector particularly heavily reliant on the technology. It is known that the level of spreadsheet error can be high and that it is often necessary to review spreadsheets based on a structured methodology which includes a cell by cell examination of the spreadsheet. This paper outlines the early research that has been carried out into the...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید
ثبت ناماگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید
ورودعنوان ژورنال:
- CoRR
دوره abs/0809.3609 شماره
صفحات -
تاریخ انتشار 2008